﻿CREATE TABLE [dbo].[Enquete] (
    [Id]                 INT           IDENTITY (1, 1) NOT NULL,
    [DataExpiracao]      DATE          NULL,
    [DataExibicaoInicio] DATE          NOT NULL,
    [DataExibicaoFinal]  DATE          NOT NULL,
    [Pergunta]           VARCHAR (255) NOT NULL,
    [AlternativaA]       VARCHAR (100) NOT NULL,
    [AlternativaB]       VARCHAR (100) NOT NULL,
    [AlternativaC]       VARCHAR (100) NULL,
    [AlternativaD]       VARCHAR (100) NULL,
    [Ativo]              BIT           NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

